#!/bin/bash
read -p "SSH user [user]: " sshuser
sshuser=${sshuser:-user}
read -p "SSH host [192.168.59.40]: " sshhost
sshhost=${sshhost:-192.168.59.40}
read -p "MySQL user [wpuser]: "  mysqluser
mysqluser=${mysqluser:-wpuser}
read -p "MySQL password [wpuser]: "  mysqlpass
mysqlpass=${mysqlpass:-wpuser}
read -p "MySQL database [wpdb]: "  mysqldatabase
mysqldatabase=${mysqldatabase:-wpdb}
read -p "Directorio de Wordpress [/var/www/wp/wordpress/]: " wpdirectory
wpdirectory=${wpdirectory:-/var/www/wp/wordpress/}
mv wordpress.tar.gz backup_$(date +%F-%T).tar.gz

ssh -t $sshuser@$sshhost "mysqldump -u $mysqluser -p$mysqlpass $mysqldatabase > '$mysqldatabase.sql'"
ssh -t $sshuser@$sshhost "sudo tar -zcvf wordpress.tar.gz '$wpdirectory' '$mysqldatabase.sql'"
scp $sshuser@$sshhost:/home/$sshuser/wordpress.tar.gz .
mv wordpress.tar.gz backup_$(date +%F-%T).tar.gz